Bentley OpenUtilities CONNECT Edition Help

To Create a New Replica Using Centralized Replication Computer

Install the following software on the centralized replication computer (if not already installed): - Oracle 9i Client and Oracle 10g Lite MDK - Bentley OpenUtilities Designer Workflow Manager Installation.
The centralized replication computer is used to create the replication publication and subscribe users who will be running Bentley OpenUtilities Designer Workflow Manager Mobile. After the subscription for a particular user, the replica (odb's) will be created using Bentley provided Replica batch file and other replication tools. The setup of the centralized computer requires that Oracle Client, Oracle Lite MDK and Bentley OpenUtilities Designer, have been installed on the computer.
Note: The following Steps 1 & 2 must be performed on the Mobile Server Machine - not on the centralized replication computer.
  1. Start the Mobile Server on Mobile Server Machine
    1. To start the Mobile Server in standalone mode, run the following shortcut: Start > All Programs > Oracle Database Lite 10g > Mobile Server.
    2. Exit the Mobile Manager by closing the window.

    If the Job Scheduler is not running, select the button next to it and click the Start button. The Status column in the Components section at the bottom of the page.

    Note: Once started the Mobile Server should be running at all times. Mobile Server is the gateway between the mobile device and the Oracle database server.
  2. Start the Job Scheduler on Mobile Server Machine.
    1. Start a browser with the URL http://<Mobile Server>/webtogo. Note that the Mobile Server host name that you provide is not the back-end database, but is the host where the Mobile Server and the middle-tier application server were installed. For Example: http://Machine2/webtogo.

      Also, the URL assumes that you are using the default port of 80. If there was a port conflict and you had to change the port number, use the URL http://<Mobile Server>:<port_number>/webtogo.

    2. Logon as the administrator. The default administrator username/password is administrator/admin unless you have mentioned a different password during the Mobile Server Installation.
    3. On the Mobile Workspace screen, click Mobile Manager. This brings up the list of Mobile Servers available.
    4. Click on the Mobile Server with which you wish to connect. These are listed by host name and port number.
    5. On the Mobile Server screen, verify that the Job Scheduler is running. This is indicated by a green checkmark under.
    Note: The following Steps must be performed on the centralized replication computer.
    Note: Before proceeding with Step 3 make sure you have the environment variable "CLASSPATH" updated. See "Setting up the CLASSPATH environment variable" for more information.
  3. Create the Replication Publication.
    Note: Step 3 is required only for the first time when publications are created. For subsequent users you can skip step 3 and go to step 4.
    1. At the command prompt, run the CREATEPUBLICATION.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
    2. Cmd:\> CreatePublication <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name> Where:
      • <Server Name> = Host name of the Master Oracle Server database.
      • <Master DB Instance> = Oracle SID of the Master database.
      • <Master User> = Username for connecting to Master database.
      • <Master Password> = Password for the Master User.
      • <Repository DB Instance> = Oracle SID of the Repository database (Usually the same as Master database).
      • <Repository User> = Username for Repository user (Usually MOBILEADMIN).
      • <Repository Password> = Password for the Repository User.
      • <Unique Name> = A name for the Workflow Manager Replication Publication.
      See Creating users in Mobile Server for details about creating the user in the Mobile Server
    3. At the command prompt, run the SUBSCRIBEUSER.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
      This name must be only two characters. For Example: Cmd:\> CreatePublication geobox elecxm chdata chadmin elecxm mobileadmin chadmin

      Note:

  4. Subscribe the users to the Replication Publication.
    Note: This step must be repeated for each Workflow Manager user.
    1. Create WorkflowManager User in Mobile Server using control center.
    2. Cmd:\> SubscribeUser <Server Name> <Master DB Instance> <Master User> <Master Password> <Repository DB Instance> <Repository User> <Repository Password> <Unique Name> <Workflow Manager Username> Where:
      • <Server Name> = Host name of the Master Oracle Server database.
      • <Master DB Instance> = Oracle SID of the Master database.
      • <Master User> = Username for connecting to Master database.
      • <Master Password> = Password for the Master User.
      • <Repository DB Instance> = Oracle SID of the Repository database (Usually the same as Master database).
      • <Repository User> = Username for Repository user (Usually MOBILEADMIN).
      • <Repository Password> = Password for the Repository User.
      • <Unique Name> = A name for the Workflow Manager Replication Publication.
        Note: This name must be only two characters.
      • <Workflow Manager Username> = Workflow Manager User name of the user who is going to the use the replication database.
        Note: This user name must exist in the Userlogin table of the Master database and in the Mobile Server prior to running the batch file. For Example: Cmd:\> SubscribeUser geobox elecxm chdata chadmin elecxm mobileadmin chadmin administrator
    At this point, you have completed creating the replication publication and subscribing the users.
  5. Create Oracle Client ODBC DSN
    1. Setup the ODBC System DSN.Note: select "Oracle in OraDb10g_home1" Driver "v10.02.00.01".
    2. Data Source Name: CHDATAMASTER Data Source Service Name: Always points to the Oracle Server SID.
  6. Create Laptop Replication Files.
    1. Edit the POLITE.INI located in C:\Windows directory like this: [All Databases] MaxSharedMemSize=256 [SYNC] AUTO_COMMIT_COUNT=50.
      Note: This step must be repeated for each ED user.
      Note: If you have any CU updates copy the CU data text files to UtilitiesDesigner directory before running REPLICA.BAT file. You can also load CU data later on using LOADDATA.BAT (See Appendix E for further details).
    2. At the command prompt, run the REPLICA.BAT utility, from ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
    3. Cmd:\> Replica <OracleLite_Home> < Username> < Username password in Mobile Server> <Mobile Server name> <proxy server> <proxy port> Where:
      • <OracleLite_Home> = Directory where you have the Oracle 10g Lite installed.
      • < Username> = Workflow Manager User name of the user who is going to the use the replication database.
        Note: This user name must exist in the Userlogin table of the Master database and in the Mobile Server prior to running the batch file. (See Appendix C for further details).
      • < Username password in Mobile Server> = Password for the above user on the Mobile Server.
      • <Mobile Server name> = Mobile Server machine name.
      • <proxy server> = [Optional] Proxy Server name
      • <proxy port> = [Optional] Proxy Port number
      For Example: Cmd:\> Replica C:\Oracle\OraLite10g administrator chadmin MACHINE1 [PROXY1] [8080]

      The REPLICA batch file performs several steps including the creation of the snapshot where each table in the Master database is replicated, loading of CU data from respective text files into the replication database, and creation of the sequence, indexes and views. After each step, the program will pause to give the System Administrator the opportunity to review any errors that may have occurred, the user can press <Enter> to continue execution or <Ctrl + C> to exit the batch program.

      One of the steps in the program is to display an interactive Windows program providing the capability to generate a sequence number. After the sequence numbers are generated, the sequences will be automatically created in the replica database.

    4. In the Sequence Generator Window:
      • Select the User's name used as a parameter to run REPLICA.BAT.
      • Select the "New Install" check box (Default is selected).
      • Select Next.
      • Select Finish to generate the sequence.
      • Manually create the CHDATALITE DSN. (Refer to instructions in Create ODBC DSNs - Oracle Lite Installed)
        Note: This step will be eliminated when Sequence Generator application is modified to create the CHDATALITE DSN.
      • Exit the Application when it has finished generating the sequence.

After the sequences are created, the batch program will continue to create views, indexes, etc.

When the program completes, the <Publication Name>.ODB file will contain the replicated database. This file will be created in the <Install directory>\Mobile\OLDB40\<Username>\.